Column | Data Type | Nullable | Default | Description |
DocumentID | int | not null | | Primary key for Document records. |
Title | nvarchar(50) | not null | | Title of the document. |
FileName | nvarchar(400) | not null | | Directory path and file name of the document |
FileExtension | nvarchar(8) | not null | | File extension indicating the document type. For example, .doc or .txt. |
Revision | nchar(5) | not null | | Revision number of the document. |
ChangeNumber | int | not null | ((0)) | Engineering change approval number. |
Status | tinyint | not null | | 1 = Pending approval, 2 = Approved, 3 = Obsolete |
DocumentSummary | nvarchar(max) | null | | Document abstract. |
Document | varbinary(max) | null | | Complete document. |
ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |